Point of Sale Tables
Note: Rows and/or Tables marked with an asterisk (*) are added to Traverse Global. Rows and/or Tables marked with a negative asterisk (-*) refer to tables and/or rows that are removed in Traverse Global.
tblPSConfig -- PS Configuration table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | bigint | 8 | |||
HostID | pWrkStnID | 20 | |||
Description | pDescription | 255 | |||
LocID | pLocID | 10 | |||
CustID | pCustID | 10 | |||
SalesRepID | pSalesRepID | 3 | |||
SalesRepRequired | bit | 1 | |||
MaxDiscount | pDecimal | 13 | |||
PmtMethodID | nvarchar | 10 | |||
TaxGroupID | pTaxLoc | 10 | |||
TransIDPrefix | nvarchar | 7 | |||
DistCode | pDistCode | 6 | |||
LayawayDays | smallint | 2 | |||
UseSpooler | bit | 1 | |||
DeviceName | nvarchar | 255 | |||
PrinterName | nvarchar | 255 | |||
CashDrawerCode | nvarchar | 255 | |||
ReceiptHeader | nvarchar | max | |||
ReceiptFooter | nvarchar | max | |||
MenuMessage | nvarchar | max | |||
ts | timestamp | 8 | |||
CF | xml | -1 |
tblPSCountDetail -- PS Count Detail table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | bigint | 8 | |||
CountID | bigint | 8 | |||
CountGroup | datetime | 8 | |||
CountType | tinyint | 1 | Count Type | 0 = Opening, 1 = Intermediate, 2 = Closing | |
UserID | bigint | 8 | |||
TenderID | bigint | 8 | |||
Quantity | int | 4 | |||
Value | pDecimal | 13 | |||
CurrencyID | pCurrency | 6 | |||
ts | timestamp | 8 | |||
CF | xml | -1 |
tblPSCountExchangeRate -- PS Count Exchange Rate table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | bigint | 8 | |||
CountID | bigint | 8 | |||
CurrencyID | pCurrency | 6 | |||
Rate | pDecimal | 13 | |||
ts | timestamp | 8 | |||
CF | xml | -1 |
tblPSCountHeader -- PS Count Header table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | bigint | 8 | |||
HostID | pWrkStnID | 20 | |||
TransDate | datetime | 8 | |||
ClosingDate | datetime | 8 | |||
EntryDate | datetime | 8 | |||
Synched | bit | 1 | |||
ts | timestamp | 8 | |||
CF | xml | -1 |
tblPSDistCode -- PS Distribution Code table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | bigint | 8 | |||
DistCode | pDistCode | 6 | |||
GLAcctSales | pGlAcct | 255 | |||
GLAcctCOGS | pGlAcct | 255 | |||
GLAcctInv | pGlAcct | 255 | |||
GLAcctDiscount | pGlAcct | 255 | |||
GLAcctCoupon | pGlAcct | 255 | |||
GLAcctLayaway | pGlAcct | 255 | |||
GLAcctRounding | pGlAcct | 255 | |||
ts | timestamp | 8 | |||
CF | xml | -1 |
tblPSFeature -- PS Feature table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | bigint | 8 | |||
ReplaceID | bigint | 8 | |||
Description | pDescription | 255 | |||
Order | smallint | 2 | |||
HideYn | bit | 1 | |||
Param | nvarchar | 255 | |||
PluginName | nvarchar | 255 | |||
AssemblyName | nvarchar | 255 | |||
ts | timestamp | 8 |
tblPSHistContact -- PS Contact History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | bigint | 8 | |||
HeaderID | bigint | 8 | |||
Type | tinyint | 1 | Contact Type | 0 = SoldTo, 1 = BillTo, 2 = ShipTo | |
Name | nvarchar | 30 | |||
Contact | nvarchar | 25 | |||
Attn | nvarchar | 30 | |||
Address1 | nvarchar | 30 | |||
Address2 | nvarchar | 60 | |||
City | nvarchar | 30 | |||
Region | nvarchar | 10 | |||
Country | pCountry | 6 | |||
PostalCode | nvarchar | 10 | |||
Phone | nvarchar | 15 | |||
Fax | nvarchar | 15 | |||
pEmail | 255 | ||||
Internet | pWeb | 255 | |||
CF | xml | -1 |
tblPSHistDetail -- PS History Detail table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | bigint | 8 | |||
HeaderID | bigint | 8 | |||
ParentID | bigint | 8 | |||
EntryNum | int | 4 | |||
LineSeq | int | 4 | |||
LineType | smallint | 2 | Line Type | 1 = Line Item, 2 = Tax, 3 = Freight, 4 = Misc, 5 = Reward Accrual, -1 = Payment, -2 = Coupon, -3 = Discount, -4 = Rounding Adjustment, -5 = Reward Redemption | |
ItemID | pItemID | 24 | |||
LocID | pLocID | 10 | |||
LotNum | pLotNum | 16 | |||
SerNum | pSerNum | 35 | |||
Descr | pDescription | 255 | |||
TaxClass | tinyint | 1 | |||
Qty | pDecimal | 13 | |||
Unit | pUom | 5 | |||
ExtPrice | pDecimal | 13 | |||
TaxAmount | pDecimal | 13 | |||
PromoID | nvarchar | 10 | |||
SalesRepID | pSalesRep | 3 | |||
GLAcct | pGlAcct | 255 | |||
GLAcctCOGS | pGlAcct | 255 | |||
GLAcctInv | pGlAcct | 255 | |||
Notes | nvarchar | max | |||
CF | xml | -1 |
tblPSHistDetailIN -- PS History Inventory Detail table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
DetailID | bigint | 8 | |||
EntryDate | datetime | 8 | |||
ExtCost | pDecimal | 13 | |||
QtySeqNum_Cmtd | int | 4 | |||
QtySeqNum | int | 4 | |||
HistSeqNum | int | 4 | |||
HistSeqNumSer | int | 4 | |||
CF | xml | -1 |
tblPSHistHeader -- PS History Header table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | bigint | 8 | |||
PostRun | pPostRun | 14 | |||
TransIDPrefix | nvarchar | 7 | |||
TransID | int | 4 | |||
TransType | smallint | 2 | Transaction Type | 1 = Invoice, 2 = Quote, 10 = Layaway, -1 = Return | |
TransDate | datetime | 8 | |||
RewardNumber | nvarchar | 255 | |||
SoldToID | pCustID | 10 | |||
BillToID | pCustID | 10 | |||
ShipToID | pCustID | 10 | |||
ShipVia | nvarchar | 20 | |||
ShipNum | nvarchar | 18 | |||
TaxableYN | bit | 1 | |||
TaxExemptID | nvarchar | 255 | |||
TaxGroupID | pTaxLoc | 10 | |||
CurrencyID | pCurrency | 6 | |||
SalesRepID | pSalesRep | 3 | |||
DueDate | datetime | 8 | |||
VoidDate | datetime | 8 | |||
UserID | bigint | 8 | |||
HostID | pWrkStnID | 20 | |||
EntryDate | datetime | 8 | |||
SourceId | uniqueidentifier | 16 | |||
LocID | pLocID | 10 | |||
DistCode | pDistCode | 6 | |||
GLAcctReceivables | pGlAcct | 255 | |||
Notes | nvarchar | max | |||
CF | xml | -1 | |||
*TaxGrpId2 | pTaxLoc |
tblPSHistPayment -- PS Payment History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | bigint | 8 | |||
PostRun | pPostRun | 14 | |||
HeaderID | bigint | 8 | |||
PmtDate | datetime | 8 | |||
CustID | pCustID | 10 | |||
PmtType | tinyint | 1 | Payment Type | 1 = Cash, 2 = Check, 3 = Credit Card, 4 = Write Off, 5 = Other, 6 = Direct Debit | |
PmtMethodID | nvarchar | 10 | |||
CcNum | nvarchar | 255 | |||
CcHolder | nvarchar | 30 | |||
CcExpire | datetime | 8 | |||
CcAuth | nvarchar | 10 | |||
CcRef | nvarchar | 255 | |||
CheckNum | pCheckNum | 10 | |||
BankName | nvarchar | 30 | |||
BankRoutingCode | nvarchar | 9 | |||
BankAcctNum | nvarchar | 255 | |||
Amount | pDecimal | 13 | |||
AmountBase | pDecimal | 13 | |||
CurrencyID | pCurrency | 6 | |||
VoidDate | datetime | 8 | |||
UserID | bigint | 8 | |||
HostID | pWrkStnID | 20 | |||
EntryDate | datetime | 8 | |||
LocID | pLocID | 10 | |||
DistCode | pDistCode | 6 | |||
GLAcctCash | pGlAcct | 255 | |||
GLAcct | pGlAcct | 255 | |||
Response | nvarchar | max | |||
Notes | nvarchar | max | |||
CF | xml | -1 |
tblPSHistTax -- PS Tax History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | bigint | 8 | |||
HeaderID | bigint | 8 | |||
TaxLocID | pTaxLoc | 10 | |||
TaxClass | tinyint | 1 | |||
TaxLevel | tinyint | 1 | |||
TaxAmt | pDecimal | 13 | |||
Taxable | pDecimal | 13 | |||
NonTaxable | pDecimal | 13 | |||
GLAcctLiability | pGlAcct | 255 | |||
CF | xml | -1 | |||
TaxGroupType | tinyint | 1 | 0 | 0 = Regular, 1 = UseTax, 2 = Extended1, 3 = Extended2 | |
ExpenseAccount | pGlAcct |
tblPSPayment -- PS Payment table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | bigint | 8 | |||
HeaderID | bigint | 8 | |||
PmtDate | datetime | 8 | |||
CustID | pCustID | 10 | |||
PmtType | tinyint | 1 | Payment Type | 1 = Cash, 2 = Check, 3 = Credit Card, 4 = Write Off, 5 = Other, 6 = Direct Debit | |
PmtMethodID | nvarchar | 10 | |||
CcNum | nvarchar | 255 | |||
CcHolder | nvarchar | 30 | |||
CcExpire | datetime | 8 | |||
CcAuth | nvarchar | 10 | |||
CcRef | nvarchar | 255 | |||
CheckNum | pCheckNum | 10 | |||
BankName | nvarchar | 30 | |||
BankRoutingCode | nvarchar | 9 | |||
BankAcctNum | nvarchar | 255 | |||
Amount | pDecimal | 13 | |||
AmountBase | pDecimal | 13 | |||
CurrencyID | pCurrency | 6 | |||
PostedYN | bit | 1 | |||
VoidDate | datetime | 8 | |||
UserID | bigint | 8 | |||
HostID | pWrkStnID | 20 | |||
EntryDate | datetime | 8 | |||
Synched | bit | 1 | |||
Settled | bit | 1 | |||
Response | nvarchar | max | |||
Notes | nvarchar | max | |||
ts | timestamp | 8 | |||
CF | xml | -1 |
tblPSRewardAccount -- PS Reward Account table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | bigint | 8 | |||
RewardNumber | nvarchar | 255 | |||
Status | tinyint | 1 | Reward Account Status | 0 = Active, 1 = Inactive | |
Type | tinyint | 1 | Reward Account Type | 0 = Regular | |
Level | tinyint | 1 | Reward Account Level | 0 = Regular | |
EnrollmentDate | datetime | 8 | |||
Name | nvarchar | 30 | |||
Address1 | nvarchar | 30 | |||
Address2 | nvarchar | 60 | |||
City | nvarchar | 30 | |||
Region | nvarchar | 10 | |||
Country | pCountry | 6 | |||
PostalCode | nvarchar | 10 | |||
Phone | nvarchar | 15 | |||
Fax | nvarchar | 15 | |||
pEmail | 255 | ||||
Internet | pWeb | 255 | |||
Synched | bit | 1 | |||
ts | timestamp | 8 | |||
CF | xml | -1 |
tblPSRewardActivity -- PS Reward Activity table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | bigint | 8 | |||
ProgramID | bigint | 8 | |||
AccountID | bigint | 8 | |||
Type | tinyint | 1 | Reward Activity Type | 0 = Accrual, 1 = Adjustment, 2 = Redemption | |
TransDate | datetime | 8 | |||
EntryDate | datetime | 8 | |||
PointQty | pDecimal | 13 | |||
PointValue | pDecimal | 13 | |||
ActivityGroup | pPostRun | 14 | |||
PostRun | pPostRun | 14 | |||
PostDate | datetime | 8 | |||
FiscalYear | smallint | 2 | |||
FiscalPeriod | smallint | 2 | |||
LiabilityAccount | pGlAcct | 255 | |||
GLAccount | pGlAcct | 255 | |||
Synched | bit | 1 | |||
ts | timestamp | 8 | |||
CF | xml | -1 |
tblPSRewardProgram -- PS Reward Program table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | bigint | 8 | |||
Description | pDescription | 255 | |||
Status | tinyint | 1 | Reward Program Status | 0 = Active, 1 = Inactive | |
Type | tinyint | 1 | Reward Program Type | 0 = Points Per Unit, 1 = Points Per Dollar | |
Prompt | tinyint | 1 | Reward Program Prompt | 0 = None, 1 = Confirm Address, 2 = Show Balance | |
StartDate | datetime | 8 | |||
EndDate | datetime | 8 | |||
PointAccrualRate | pDecimal | 13 | |||
PointValue | pDecimal | 13 | |||
LiabilityAccount | pGlAcct | 255 | |||
ExpenseAccount | pGlAcct | 255 | |||
RedemptionRate | pDecimal | 13 | |||
Synched | bit | 1 | |||
ts | timestamp | 8 | |||
CF | xml | -1 |
tblPSTender -- PS Tender table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | bigint | 8 | |||
Description | pDescription | 255 | |||
Type | tinyint | 1 | Tender Type | 0 = Cash, 1 = Check, 2 = Coupon, 3 = Credit Card, 4 = Other | |
Value | pDecimal | 13 | |||
CurrencyID | pCurrency | 6 | |||
PmtMethodID | nvarchar | 10 | |||
ts | timestamp | 8 | |||
CF | xml | -1 |
tblPSTransContact -- PS Transaction Contact table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | bigint | 8 | |||
HeaderID | bigint | 8 | |||
Type | tinyint | 1 | Contact Type | 0 = Sold To, 1 = Bill To, 2 = Ship To | |
Name | nvarchar | 30 | |||
Contact | nvarchar | 25 | |||
Attn | nvarchar | 30 | |||
Address1 | nvarchar | 30 | |||
Address2 | nvarchar | 60 | |||
City | nvarchar | 30 | |||
Region | nvarchar | 10 | |||
Country | pCountry | 6 | |||
PostalCode | nvarchar | 10 | |||
Phone | nvarchar | 15 | |||
Fax | nvarchar | 15 | |||
pEmail | 255 | ||||
Internet | pWeb | 255 | |||
ts | timestamp | 8 | |||
CF | xml | -1 |
tblPSTransDetail -- PS Transaction Detail table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | bigint | 8 | |||
HeaderID | bigint | 8 | |||
ParentID | bigint | 8 | |||
EntryNum | int | 4 | |||
LineSeq | int | 4 | |||
LineType | smallint | 2 | Line Type | 1 = Line Item, 2 = Tax, 3 = Freight, 4 = Misc, 5 = Reward Accrual, -1 = Payment, -2 = Coupon, -3 = Discount, -4 = Rounding Adjustment, -5 = Reward Redemption | |
ItemID | pItemID | 24 | |||
LocID | pLocID | 10 | |||
LotNum | pLotNum | 16 | |||
SerNum | pSerNum | 35 | |||
Descr | pDescription | 255 | |||
TaxClass | tinyint | 1 | |||
Qty | pDecimal | 13 | |||
Unit | pUom | 5 | |||
ExtPrice | pDecimal | 13 | |||
TaxAmount | pDecimal | 13 | |||
PromoID | nvarchar | 10 | |||
SalesRepID | pSalesRep | 3 | |||
Notes | nvarchar | max | |||
ts | timestamp | 8 | |||
CF | xml | -1 |
tblPSTransDetailIN -- PS Transaction Inventory Detail table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
DetailID | bigint | 8 | |||
EntryDate | datetime | 8 | |||
ExtCost | pDecimal | 13 | |||
QtySeqNum | Cmtd | 4 | |||
QtySeqNum | int | 4 | |||
HistSeqNum | int | 4 | |||
HistSeqNumSer | int | 4 | |||
ts | timestamp | 8 | |||
CF | xml | -1 |
tblPSTransHeader -- PS Transaction Header table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | bigint | 8 | |||
TransIDPrefix | nvarchar | 7 | |||
TransID | int | 4 | |||
TransType | smallint | 2 | Transaction Type | 1 = Invoice, 2 = Quote, 10 = Layaway, -1 = Return | |
TransDate | datetime | 8 | |||
RewardNumber | nvarchar | 255 | |||
SoldToID | pCustID | 10 | |||
BillToID | pCustID | 10 | |||
ShipToID | pCustID | 10 | |||
ShipVia | nvarchar | 20 | |||
ShipNum | nvarchar | 18 | |||
TaxableYN | bit | 1 | |||
TaxExemptID | nvarchar | 255 | |||
TaxGroupID | pTaxLoc | 10 | |||
CurrencyID | pCurrency | 6 | |||
SalesRepID | pSalesRep | 3 | |||
DueDate | datetime | 8 | |||
VoidDate | datetime | 8 | |||
SuspendDate | datetime | 8 | |||
UserID | bigint | 8 | |||
HostID | pWrkStnID | 20 | |||
EntryDate | datetime | 8 | |||
Synched | bit | 1 | |||
SourceId | uniqueidentifier | 16 | |||
Notes | nvarchar | max | |||
ts | timestamp | 8 | |||
CF | xml | -1 | |||
*TaxGrpId2 | pTaxLoc |
tblPSTransID -- PS Transaction ID table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
HostID | pWrkStnID | 20 | |||
NextID | int | 4 | |||
ts | timestamp | 8 |
tblPSTransTax -- PS Transaction Tax table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | bigint | 8 | |||
HeaderID | bigint | 8 | |||
TaxLocID | pTaxLoc | 10 | |||
TaxClass | tinyint | 1 | |||
TaxLevel | tinyint | 1 | |||
TaxAmt | pDec | 13 | |||
Taxable | pDec | 13 | |||
NonTaxable | pDec | 13 | |||
ts | timestamp | 8 | |||
CF | xml | -1 | |||
TaxGroupType | tinyint | 1 | 0 | 0 = Regular, 1 = UseTax, 2 = Extended1, 3 = Extended2 | |
ExpenseAccount | pGlAcct | Comment: PS Trans Tax does not need to include GL Accounts |
tblPSUser --PS User table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | bigint | 8 | |||
UserName | pUserID | 20 | |||
Password | nvarchar | max | |||
EmployeeID | pEmpID | 11 | |||
SalesRepID | pSalesRep | 3 | |||
HostID | pWrkStnID | 20 | |||
ts | timestamp | 8 | |||
CF | xml | -1 |
tblPSUserPermission -- PS User Permission table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | bigint | 8 | |||
UserID | bigint | 8 | |||
HostID | pWrkStnID | 20 | |||
FeatureID | bigint | 8 | |||
ts | timestamp | 8 | |||
CF | xml | -1 |